package com.dhecp.project.api.mapper;

import com.dhecp.core.genericDao.GenericDao;
import com.dhecp.project.api.domain.FbaPlanOrderDetail;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

/**
 * DAO
 * @author Jason
 */
public interface FbaPlanOrderDetailMapper extends GenericDao<FbaPlanOrderDetail, String>  {

	/**
     * 查询实体
     * @author Jason
	 */
	List<FbaPlanOrderDetail> findFbaPlanOrderDetail(Map<String, Object> params);

	/**
     * 查询单个实体
     * @author Jason
	 */
	FbaPlanOrderDetail queryFirstByGuid(@Param("guid") String guid);


	
	/**
	 * 新增实体
     * @author Jason
	 */
	int insertFbaPlanOrderDetail(FbaPlanOrderDetail entity);
	
	/**
	 * 通过guid修改实体
     * @author Jason
	 */
	int updateByGuid(FbaPlanOrderDetail entity);

	int deleteCodePlanOrder(@Param("code") String code);

    List<FbaPlanOrderDetail> queryList(Map<String, Object> params);

    //查询相同sku的计划单数据 合并计划发货数量
    List<FbaPlanOrderDetail> queryListSum(Map<String, Object> params);

	List<FbaPlanOrderDetail> queryListCode(@Param("code") String code);

	/**
	 * 获取文件路径
	 * @param code
	 * @return
	 */
	List<String> queryListFilePath(@Param("code") String code);

}
